80 Crystal Reports 100 SELECT tabname, owner FROM systables WHERE tabid > 0 101 ; 102 sp_tables 103 SELECT a.name, c.name, a.type FROM sysusers c, sysobjects a WHERE a.uid = c.uid 104 SELECT name FROM sysdatabases 106 SELECT syscolumns.name, syscolumns.type, syscolumns.length 107 No default database defined. Please specify a database name 108 256 109 8 110 _ 111 AND owner LIKE 112 AND tabname LIKE 113 AND tabtype IN 114 SELECT COUNT(*) FROM systables WHERE tabid > 0 115 SELECT COUNT(*) FROM sysusers c, sysobjects a WHERE a.uid = c.uid 116 SELECT COUNT (*) 117 Database Not Found 118 Warning: %d table names will be returned.\nProceed? 119 Allow Reporting On 120 Unable To Connect to SQL Server %s 128 AND tabid BETWEEN 1 AND 24 129 AND tabid >= 100 130 SELECT procname, owner FROM sysprocedures WHERE mode IN ('D','O','P') 131 ; 132 AND procname LIKE 133 COUNT(*) 134 select data from informix.sysprocbody where datakey = 'T' and seqno = 1 135 and procid = (select procid from informix.sysprocedures where informix.sysprocedures.procname = '%s') 136 EXECUTE PROCEDURE 137 sysmaster 200 3 201 4 202 5 203 7 204 8 205 9 206 10 207 11 300 = Equal Join 301 = Left Outer Join 302 = Right Outer Join 303 > Greater Join 304 < Less Join 305 >= Greater Or Equal 306 <= Less Or Equal 307 != Not Equal Join 400 = 401 = 402 = 403 = 404 = 405 = 406 = 407 > 408 < 409 >= 410 <= 411 != 1000 HEX\n11\n1\n7\n0 1200 ABS\n7\n1\n7\n0 1201 MOD\n7\n2\n7\n7\n0 1202 POW\n7\n2\n7\n7\n0 1203 ROOT\n7\n1\n7\n8 1204 ROUND\n7\n1\n7\n8 1205 SQRT\n7\n1\n7\n0 1206 TRUNC\n7\n1\n7\n8 1207 COS\n7\n1\n7\n0 1208 SIN\n7\n1\n7\n0 1209 TAN\n7\n1\n7\n0 1210 ASIN\n7\n1\n7\n0 1211 ACOS\n7\n1\n7\n0 1212 ATAN\n7\n1\n7\n0 1213 ATAN2\n7\n2\n7\n7\n0 1214 EXP\n7\n1\n7\n0 1215 LOGN\n7\n1\n7\n0 1216 LOG10\n7\n1\n7\n0 1400 LENGTH\n4\n1\n11\n0 1401 OCTET_LENGTH\n4\n1\n11\n0 1402 CHAR_LENGTH\n4\n1\n11\n0 1403 CHARACTER_LENGTH\n4\n1\n11\n0 1404 TRIM\n11\n1\n11\n0 1600 USER\n11\n0\n4 1601 DBSERVERNAME\n11\n0\n4 1602 SITENAME\n11\n0\n4 1603 TODAY\n9\n0\n4 1604 CURRENT\n15\n0\n4 1800 DATE\n9\n1\n255\n0 1801 DAY\n4\n1\n255\n0 1802 MONTH\n4\n1\n255\n0 1803 YEAR\n4\n1\n255\n0 1804 WEEKDAY\n4\n1\n255\n0 1805 MDY\n9\n3\n4\n4\n4\n0 2000 AVG\n7\n1\n255\n1 2001 MAX\n250\n1\n255\n1 2002 MIN\n250\n1\n255\n1 2003 SUM\n250\n1\n255\n1 2004 COUNT\n4\n1\n255\n1 2005 RANGE\n250\n1\n255\n0 2006 STDEV\n7\n1\n255\n0 2007 VARIANCE\n7\n1\n255\n0 4048 SQL Command Failed 4304 SELECT 4305 FROM 4306 WHERE 4307 systables 4308 sysprocedures 4309 tabid >= 100 AND tabtype IN ('T') 4310 tabid >= 100 AND tabtype IN ('V') 4311 tabid >= 100 AND tabtype IN ('S', 'P') 4312 tabid BETWEEN 1 AND 24 4313 mode IN ('D', 'O', 'P') 4314 AND procname LIKE 4315 tabname, owner 4316 procname, owner 4317 Login Error 4318 The procedure definition contains an error. Precision cannot be smaller or equal to the number of decimals. 4319 The procedure definition contains an error.